Tabela DrugPosition

Definicja tabeli DrugPosition

Name

DrugPosition

Code

DrugPosition

Comment

 


Lista kolumn tabeli DrugPosition

Name

Code

DrugPositionID

DrugPositionID

DrugInvoiceID

DrugInvoiceID

MedicalProductDefinitionID

MedicalProductDefinitionID

CorrectedDrugInvoiceID

CorrectedDrugInvoiceID

CorrectedDrugPositionID

CorrectedDrugPositionID

PackagesNumber

PackagesNumber

Value

Value

TotalItemsQuantity

TotalItemsQuantity

TotalActiveSubstanceQuantity

TotalActiveSubstanceQuantity

PositionNumber

PositionNumber

PackagePrice

PackagePrice

EAN

EAN

DrugType

DrugType

extPosition

extPosition

ProductName

ProductName


Kolumna DrugPositionID tabeli DrugPosition

Definicja kolumny DrugPositionID tabeli DrugPosition

Name

DrugPositionID

Code

DrugPositionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DrugInvoiceID tabeli DrugPosition

Definicja kolumny DrugInvoiceID tabeli DrugPosition

Name

DrugInvoiceID

Code

DrugInvoiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MedicalProductDefinitionID tabeli DrugPosition

Definicja kolumny MedicalProductDefinitionID tabeli DrugPosition

Name

MedicalProductDefinitionID

Code

MedicalProductDefinitionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CorrectedDrugInvoiceID tabeli DrugPosition

Definicja kolumny CorrectedDrugInvoiceID tabeli DrugPosition

Name

CorrectedDrugInvoiceID

Code

CorrectedDrugInvoiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

faktura korygowana


Kolumna CorrectedDrugPositionID tabeli DrugPosition

Definicja kolumny CorrectedDrugPositionID tabeli DrugPosition

Name

CorrectedDrugPositionID

Code

CorrectedDrugPositionID

Data Type

NUMBER(10)

Mandatory

No

Comment

pozycja korygowana z faktury korygowanej


Kolumna PackagesNumber tabeli DrugPosition

Definicja kolumny PackagesNumber tabeli DrugPosition

Name

PackagesNumber

Code

PackagesNumber

Data Type

NUMBER(14,5)

Mandatory

No

Comment

 


Kolumna Value tabeli DrugPosition

Definicja kolumny Value tabeli DrugPosition

Name

Value

Code

Value

Data Type

NUMBER(15,2)

Mandatory

No

Comment

 


Kolumna TotalItemsQuantity tabeli DrugPosition

Definicja kolumny TotalItemsQuantity tabeli DrugPosition

Name

TotalItemsQuantity

Code

TotalItemsQuantity

Data Type

NUMBER(15,5)

Mandatory

No

Comment

 


Kolumna TotalActiveSubstanceQuantity tabeli DrugPosition

Definicja kolumny TotalActiveSubstanceQuantity tabeli DrugPosition

Name

TotalActiveSubstanceQuantity

Code

TotalActiveSubstanceQuantity

Data Type

NUMBER(17,5)

Mandatory

No

Comment

 


Kolumna PositionNumber tabeli DrugPosition

Definicja kolumny PositionNumber tabeli DrugPosition

Name

PositionNumber

Code

PositionNumber

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PackagePrice tabeli DrugPosition

Definicja kolumny PackagePrice tabeli DrugPosition

Name

PackagePrice

Code

PackagePrice

Data Type

NUMBER(8,2)

Mandatory

No

Comment

cena opak. leku


Kolumna EAN tabeli DrugPosition

Definicja kolumny EAN tabeli DrugPosition

Name

EAN

Code

EAN

Data Type

VARCHAR2(14)

Mandatory

No

Comment

kod EAN


Kolumna DrugType tabeli DrugPosition

Definicja kolumny DrugType tabeli DrugPosition

Name

DrugType

Code

DrugType

Data Type

VARCHAR2(3)

Mandatory

No

Comment

Szczególowe okreslenie typu leku


Kolumna extPosition tabeli DrugPosition

Definicja kolumny extPosition tabeli DrugPosition

Name

extPosition

Code

extPosition

Data Type

VARCHAR2(66)

Mandatory

No

Comment

klucz systemu zewnetrznego pozycji w fakturze lekowej


Kolumna ProductName tabeli DrugPosition

Definicja kolumny ProductName tabeli DrugPosition

Name

ProductName

Code

ProductName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Lista kluczy tabeli DrugPosition

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DrugPosition

Definicja klucza Identifier_1 tabeli DrugPosition

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment